MacWorld 1996 July

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Examples / Templates w⁄data / Business / Cash Receipts (.txt) < prev next >

Wrap

FileMaker Pro Database | 1996-01-25 | 109KB | 780 lines

GZTc1A7ge}n HBAM2016AUG95 Pro 3.0 ;!43# ;t9 l T fr+ C;Mb# AJ{jiJnp H@.@s f]E6c rF8?N HBAM3016AUG95@ Pro 2.0 - 2.1F! Pro 3.0 AMOUNT CASH RECEIPT ID CATEGORY CREATED BY DATE CREATED DATE MODIFIED DATE OF RECEIPT MNTHNME OF RCPT MONTH OF RCPT PAID TO RECEIPT FOR SUBSUMM HDR TOTAL OF AMOUNT YEAR OF RECEIPT Cash Receipt IDB Receipt ForB CategoryB AmountB Date of ReceiptB Date CreatedB Date ModifiedB Total of AmountB Paid ToB Created ByB MnthNme of RcptB Year of ReceiptB Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11/20/95 SubSumm HdrB / & ", " & Month of RcptB InfoB Description Use this database to keep track of those hard-to-manage cash receipts. Just enter your receipt information on a regular basis to make it easier to organize your financial records. How to use this solution Enter in your information and print a cash receipts report, which you can use to prepare your taxes. How to customize this solution Edit the Category list to reflect your needs. To edit the list, select the Category field in the Form View layout in Layout mode. Choose Field "AfA Form View A List View Receipt Summary Information Report Menu A Form ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Format from the Format menu. In the Value List pop-up menu (that currently says "Category List"), choose Define Value List , and add or delete values. Create a new report that sorts the receipts by category. To do this, simply use the Receipt Summary layout, sort by Category and select Preview from the Layout menu. For details on sorting and preview, see the FileMaker Pro documentation. A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button{ Your Own Button| Record} Delete Record~ Record Reports View As View As Close Category Paid To Amount Receipt For Enter data for Cash Receipts J THANK YOU CASH RECEIPT Receipt SummaryB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Amount\ Category] Paid To^ Receipt For_ Date` Your Own Buttona Your Own Buttonb Recordc Delete Recordd Recorde Reportsf View As Listg View As Formh Closei Infoj0Click to see more information for a Cash Receipt InformationB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Reports View As View As Close Grand Total: Paid To Receipt For Page ## Cash Receipts Summary Amount 166.77 25.92 25.92 25.92 25.92 25.92 25.92 25.92 25.92 25.92 25.92 25.92 25.92 Sort by Date Sort by Category Sort by Amount Sort for Monthly Summary Monthly Summary Open Script Sort by Date Monthly Summary Sort by Category Report MenuB Your Own ButtonI ReportsJ View As ListK View As FormL CloseM InfoO,Information about the Cash Receipts solutionP Info for this Solution about the Cash Receipts solutionP Info for this Solution Your Own ReportB Your Own ReportC Your Own ReportD Monthly SummaryE Your Own ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report Lunch with Sonia LongE MealsG 22.65H 4/7/95X 05/06/95Y 5/25/95e The Delin Paul Farraho Aprilp 1995q April, 1995r ParkingE Parking FeesG 13.68H 4/8/95X 05/06/95Y 5/25/95e The Parking Placen Paul Farraho Aprilp 1995q April, 1995r Window CleanerE Cleaning SuppliesG 3.58H 4/18/95X 05/06/95Y 5/25/95e General Storen Paul Farraho Aprilp 1995q April, 1995r Lunch with Jennifer NorizE MealsG 23.49H 4/19/95X 05/06/95Y 5/25/95e The Delin Paul Farraho Aprilp 1995q April, 1995r StampsE PostageG 5/1/95X 05/06/95Y 5/25/95e Post Officen Paul Farraho 1995q May, 1995r Bridge TollE TollsG 5/1/95X 05/06/95Y 5/25/95e Cityn Paul Farraho 1995q May, 1995r TaxiE TransportationG 12.50H 5/6/95X 05/06/95Y 5/25/95e Cab Companyn Paul Farraho 1995q May, 1995r Lunch with Dennis SmithE MealsG 19.95H 5/25/95X 5/25/95Y 5/25/95e The Delin Tony Campitellio Your Own ButtonB ReportsC View As ListD View As FormE CloseF meals meals cleaning supplies meals parking parking cleaning supplies meals meals office supplies postage tolls transportation postage tolls transportation meals office supplies Sort by Date Sort by Category Sort by Amount Sort for Monthly Summary Monthly Summary Open Script Sort by Date Monthly Summary Sort by Category q May, 1995r Printer PaperE Office SuppliesG 9.99H 5/27/95X 5/25/95Y 5/25/95e The Office Shopn Tony Campitellio 1995q May, 1995r 3 ring BinderE Office SuppliesG 5.95H 5/28/95X 5/25/95Y 5/25/95e The Office Shopn Tony Campitellio 1995q May, 1995r 11C Fax PaperE Office SuppliesG 9.98H 5/30/95X 5/25/95Y 5/25/95e The Office Shopn Tony Campitellio 1995q May, 1995r Yesfter Noarter Helvetica Geneva Times Times New Roman Arial MS Sans Serif Script Sort by Amount Sort for Monthly Summary Open Script ) = 400 Cancel You did not enter any find criteria; all records will be displayed.C+ ) = 0 Cancel No records match this request.E+ ) = 1 wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! wwwwww ffffff UUUUUU DDDDDD 3333B """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw (LIST LISTA Cleaning Supplies Entertainment Gasoline Groceries Meals Office Supplies Parking Fees Photocopies Postage Software Tolls Transportation Miscellaneous VDEFA( Category List wwwwww ffffff UUUUUU DDDDDD wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" wwwwww ffffff UUUUUU DDDDDD #4EWp "4EVx #3EVg "4DUg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww "%UR UD33D AD@D@ AD@D@ B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"D0#C0 4""#C0 44444 CCCCC 44444 CCCCC $42" bRBBP0 @@BA@ JJJJ !BBBB "99BB #9999 $9911 %1111 &))))C '!!!! *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! UUUUU (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,*,1! !$&(265389,#!$$ '275? $*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:<H /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)!L //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+N &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10// 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!P 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%Q &' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.R 94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFG CA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9<3)" 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,0V 27CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 6=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*,169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,Z *3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7 !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21\ .7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww UUUUUU wwwwww ) = 400 Cancel You did not enter any find criteria; all records will be displayed.C+ ) = 0 Cancel No records match this request.E+ ) = 1 Sort by Date Sort by Category Sort by Amount Sort for Monthly Summary Monthly Summary Open Script Sort by Date Monthly Summary Sort by Category Sort by Date Sort by Category Sort by Amount Sort for Monthly Summary Monthly Summary Open Script Sort by Date Monthly Summary Sort by Category